[Toplink] How to add c3p0 or DBCP Connection pool?

Posted by Jean N.T. on Stack Overflow See other posts from Stack Overflow or by Jean N.T.
Published on 2010-04-13T15:22:50Z Indexed on 2010/04/14 10:32 UTC
Read the original article Hit count: 420

Filed under:

toplink

|

jpa

|

c3po

|

dbcp

|

pool

Hello,

Could you please explain to me how to add a standalone c3pO or DBCP connection pool to my toplink-based JPA project?

I have a persistence.xml file, and everytime I want to query the database, I'm doing this:

EntityManagerFactory emf = this.getEntityManagerFactory();

// Surely using persistence.xml to set up the factory

EntityManager em = emf.createEntityManager(); ...

Where do I build the bridge between my external connection pool manager and Toplink? Any ideas or links are welcomed.

Regards, Jean

© Stack Overflow or respective owner

Related posts about toplink

Netbeans / persistence API error

as seen on Stack Overflow - Search for 'Stack Overflow'
I am following this tutorial, I'm using netbeans 6.5.1 http://www.netbeans.org/kb/docs/java/gui-db-custom.html When I get to the part where I create the "new entity class from database", which is in the "Customizing the Master/Detail View" section of the tutoiral. I can't ever compile because I… >>> More
specify query timeout when using toplink essential query hint

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, For glassfish v2, I have searched through the web and I cannot find anyway to specify query timeout when using TopLink essential query hint. We have another option to migrate to EclipseLink but that is not feasible. have tried the solution in http://forums.oracle.com/forums/thread.jspa?threadID=974732&tstart=-1 but… >>> More
Toplink Exception, whats wrong?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey, I've got an excpetion when I generate this EJB SQL Statement. Exception Description: Syntax error parsing the query [SELECT h FROM Busmodul h WHERE LOWER(h.modulNummer) LIKE :modulnummer AND h.einbauort.id = :einbauort_fk AND h.plattform.id = :plattform_fk ORDER BY TRIM(TRAILING '-' FROM… >>> More
Regarding Toplink Fetching Policy

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm working for a Swing Project and the technologies used are netbeans with Toplink essentials, mysql. The Problem I'm facing is the entity object dosn't get updated after insertions take place while calling a getter collection of the foreign key property. Ex: I have 2 tables Table1,Table2… >>> More
Toplink client session

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there any way i can access the object of one client session from another client session? >>> More

Related posts about jpa

Detach an entity from a JPA persistence context (JPA 2.0 / Hibernate / EJB 3 / J2EE 6)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I wrote a stateless EJB method allowing to get an entity in "read-only" mode. The way to do this is to get the entity with the EntityManager then detach it (using the JPA 2.0 EntityManager). My code is the following: @PersistenceContext private EntityManager entityManager; public T getEntity(int… >>> More
AndroMDA maven code generation and JPA Annotations

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using the AndroMDA plugin for maven to generate code from an uml diagram made in MagicDraw. When the code is generated, AndroMDA desings the JPA annotation for the persitence layer. I think that at the compilation process AndroMDA uses Naming Strategies to determine the Table and Column names… >>> More
How to populate Java (web) application with initial data using Spring/JPA/Hibernate

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to setup my database with initial data programmatically. I want to populate my database for development runs, not for testing runs (it's easy). The product is built on top of Spring and JPA/Hibernate. Developer checks out the project Developer runs command/script to setup database with initial… >>> More
Eclipselink problem in a javase project

as seen on Stack Overflow - Search for 'Stack Overflow'
I am getting this error when I am running my eclipselink project. [EL Warning]: 2008.12.05 11:47:08.056--java.lang.NoClassDefFoundError: org/jboss/resource/adapter/jdbc/ValidConnectionChecker was thrown on attempt of PersistenceLoadProcessor to load class com.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker… >>> More
JPA thinks I'm deleting a detached object

as seen on Stack Overflow - Search for 'Stack Overflow'
So, I've got a DAO that I used to load and save my domain objects using JPA. I finally managed to get the transaction stuff working (with a bunch of help from the folks here...), now I've got another issue. In my test case, I call my DAO to load a domain object with a given id, check that it got… >>> More